/**
 *查询行政区下拉框
 */
'use strict';

const conn = require('../../libs/DB/Conn');

module.exports = async function (params) {
   let downDropList = await conn(`SELECT district_id AS value,district_name AS label FROM district_file WHERE delete_sign = 1 ${params.parentId && params.parentId !=="" ? `AND parent_id = ${params.parentId}` : "AND parent_id = 0"}`);
   return {success:true,downDropList:downDropList}
};
